using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VTIMEZONE
    {
        public DataRow Convert2TIMEZONE(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryTIMEZONE(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["TZNAME"] = " ".PadRight(8 ); 
         dwReturn["TZAENDZL"] = " ".PadRight(0 ); 
         dwReturn["TZAENDBEN"] = " ".PadRight(8 ); 
         dwReturn["TZAENDDAT"] = " ".PadRight(0 ); 
         dwReturn["TZNEUBEN"] = " ".PadRight(8 ); 
         dwReturn["TZNEUDAT"] = " ".PadRight(0 ); 
         dwReturn["TZSTATUS"] = " ".PadRight(1 ); 
         dwReturn["TZREMARK"] = " ".PadRight(50 ); 
         dwReturn["TZUTC"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMERTIME"] = " ".PadRight(8 ); 
         dwReturn["TZSUMMSDATE1"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME1"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK1"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE1"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME1"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK1"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER1"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE2"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME2"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK2"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE2"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME2"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK2"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER2"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE3"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME3"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK3"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE3"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME3"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK3"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER3"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE4"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME4"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK4"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE4"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME4"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK4"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER4"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE5"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME5"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK5"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE5"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME5"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK5"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER5"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE6"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME6"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK6"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE6"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME6"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK6"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER6"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE7"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME7"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK7"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE7"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME7"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK7"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER7"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE8"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME8"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK8"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE8"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME8"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK8"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER8"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE9"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME9"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK9"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE9"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME9"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK9"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER9"] = " ".PadRight(10 ); 
         dwReturn["TZSUMMSDATE10"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSTIME10"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMSOK10"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMEDATE10"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMETIME10"] = " ".PadRight(0 ); 
         dwReturn["TZSUMMEOK10"] = " ".PadRight(1 ); 
         dwReturn["TZSUMMFILLER10"] = " ".PadRight(10 ); 
         dwReturn["TZFILLER"] = " ".PadRight(165 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapTIMEZONE(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveTIMEZONE(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryTIMEZONE(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapTIMEZONE(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertTIMEZONE(dwLocal, ITXDBVERSION);
            }
            UpdateTIMEZONE(dwLocal);
        }
        public void InsertTIMEZONE(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO TIMEZONE(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryTIMEZONE(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM TIMEZONE WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM TIMEZONE  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "TIMEZONE";
            Return = Result;
            return Return;
        }
        public void DeleteTIMEZONE(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM TIMEZONE   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateTIMEZONE(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE TIMEZONE SET "
                    +"TZNAME= :TZNAME,"
                    +"TZAENDZL= :TZAENDZL,"
                    +"TZAENDBEN= :TZAENDBEN,"
                    +"TZAENDDAT= :TZAENDDAT,"
                    +"TZNEUBEN= :TZNEUBEN,"
                    +"TZNEUDAT= :TZNEUDAT,"
                    +"TZSTATUS= :TZSTATUS,"
                    +"TZREMARK= :TZREMARK,"
                    +"TZUTC= :TZUTC,"
                    +"TZSUMMERTIME= :TZSUMMERTIME,"
                    +"TZSUMMSDATE1= :TZSUMMSDATE1,"
                    +"TZSUMMSTIME1= :TZSUMMSTIME1,"
                    +"TZSUMMSOK1= :TZSUMMSOK1,"
                    +"TZSUMMEDATE1= :TZSUMMEDATE1,"
                    +"TZSUMMETIME1= :TZSUMMETIME1,"
                    +"TZSUMMEOK1= :TZSUMMEOK1,"
                    +"TZSUMMFILLER1= :TZSUMMFILLER1,"
                    +"TZSUMMSDATE2= :TZSUMMSDATE2,"
                    +"TZSUMMSTIME2= :TZSUMMSTIME2,"
                    +"TZSUMMSOK2= :TZSUMMSOK2,"
                    +"TZSUMMEDATE2= :TZSUMMEDATE2,"
                    +"TZSUMMETIME2= :TZSUMMETIME2,"
                    +"TZSUMMEOK2= :TZSUMMEOK2,"
                    +"TZSUMMFILLER2= :TZSUMMFILLER2,"
                    +"TZSUMMSDATE3= :TZSUMMSDATE3,"
                    +"TZSUMMSTIME3= :TZSUMMSTIME3,"
                    +"TZSUMMSOK3= :TZSUMMSOK3,"
                    +"TZSUMMEDATE3= :TZSUMMEDATE3,"
                    +"TZSUMMETIME3= :TZSUMMETIME3,"
                    +"TZSUMMEOK3= :TZSUMMEOK3,"
                    +"TZSUMMFILLER3= :TZSUMMFILLER3,"
                    +"TZSUMMSDATE4= :TZSUMMSDATE4,"
                    +"TZSUMMSTIME4= :TZSUMMSTIME4,"
                    +"TZSUMMSOK4= :TZSUMMSOK4,"
                    +"TZSUMMEDATE4= :TZSUMMEDATE4,"
                    +"TZSUMMETIME4= :TZSUMMETIME4,"
                    +"TZSUMMEOK4= :TZSUMMEOK4,"
                    +"TZSUMMFILLER4= :TZSUMMFILLER4,"
                    +"TZSUMMSDATE5= :TZSUMMSDATE5,"
                    +"TZSUMMSTIME5= :TZSUMMSTIME5,"
                    +"TZSUMMSOK5= :TZSUMMSOK5,"
                    +"TZSUMMEDATE5= :TZSUMMEDATE5,"
                    +"TZSUMMETIME5= :TZSUMMETIME5,"
                    +"TZSUMMEOK5= :TZSUMMEOK5,"
                    +"TZSUMMFILLER5= :TZSUMMFILLER5,"
                    +"TZSUMMSDATE6= :TZSUMMSDATE6,"
                    +"TZSUMMSTIME6= :TZSUMMSTIME6,"
                    +"TZSUMMSOK6= :TZSUMMSOK6,"
                    +"TZSUMMEDATE6= :TZSUMMEDATE6,"
                    +"TZSUMMETIME6= :TZSUMMETIME6,"
                    +"TZSUMMEOK6= :TZSUMMEOK6,"
                    +"TZSUMMFILLER6= :TZSUMMFILLER6,"
                    +"TZSUMMSDATE7= :TZSUMMSDATE7,"
                    +"TZSUMMSTIME7= :TZSUMMSTIME7,"
                    +"TZSUMMSOK7= :TZSUMMSOK7,"
                    +"TZSUMMEDATE7= :TZSUMMEDATE7,"
                    +"TZSUMMETIME7= :TZSUMMETIME7,"
                    +"TZSUMMEOK7= :TZSUMMEOK7,"
                    +"TZSUMMFILLER7= :TZSUMMFILLER7,"
                    +"TZSUMMSDATE8= :TZSUMMSDATE8,"
                    +"TZSUMMSTIME8= :TZSUMMSTIME8,"
                    +"TZSUMMSOK8= :TZSUMMSOK8,"
                    +"TZSUMMEDATE8= :TZSUMMEDATE8,"
                    +"TZSUMMETIME8= :TZSUMMETIME8,"
                    +"TZSUMMEOK8= :TZSUMMEOK8,"
                    +"TZSUMMFILLER8= :TZSUMMFILLER8,"
                    +"TZSUMMSDATE9= :TZSUMMSDATE9,"
                    +"TZSUMMSTIME9= :TZSUMMSTIME9,"
                    +"TZSUMMSOK9= :TZSUMMSOK9,"
                    +"TZSUMMEDATE9= :TZSUMMEDATE9,"
                    +"TZSUMMETIME9= :TZSUMMETIME9,"
                    +"TZSUMMEOK9= :TZSUMMEOK9,"
                    +"TZSUMMFILLER9= :TZSUMMFILLER9,"
                    +"TZSUMMSDATE10= :TZSUMMSDATE10,"
                    +"TZSUMMSTIME10= :TZSUMMSTIME10,"
                    +"TZSUMMSOK10= :TZSUMMSOK10,"
                    +"TZSUMMEDATE10= :TZSUMMEDATE10,"
                    +"TZSUMMETIME10= :TZSUMMETIME10,"
                    +"TZSUMMEOK10= :TZSUMMEOK10,"
                    +"TZSUMMFILLER10= :TZSUMMFILLER10,"
                    +"TZFILLER= :TZFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("TZNAME", OracleType.NVarChar).Value = dwData["TZNAME"].ToString(); 
          or1.Parameters.Add("TZAENDZL", OracleType.NVarChar).Value = dwData["TZAENDZL"].ToString(); 
          or1.Parameters.Add("TZAENDBEN", OracleType.NVarChar).Value = dwData["TZAENDBEN"].ToString(); 
          or1.Parameters.Add("TZAENDDAT", OracleType.NVarChar).Value = dwData["TZAENDDAT"].ToString(); 
          or1.Parameters.Add("TZNEUBEN", OracleType.NVarChar).Value = dwData["TZNEUBEN"].ToString(); 
          or1.Parameters.Add("TZNEUDAT", OracleType.NVarChar).Value = dwData["TZNEUDAT"].ToString(); 
          or1.Parameters.Add("TZSTATUS", OracleType.NVarChar).Value = dwData["TZSTATUS"].ToString(); 
          or1.Parameters.Add("TZREMARK", OracleType.NVarChar).Value = dwData["TZREMARK"].ToString(); 
          or1.Parameters.Add("TZUTC", OracleType.NVarChar).Value = dwData["TZUTC"].ToString(); 
          or1.Parameters.Add("TZSUMMERTIME", OracleType.NVarChar).Value = dwData["TZSUMMERTIME"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE1", OracleType.NVarChar).Value = dwData["TZSUMMSDATE1"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME1", OracleType.NVarChar).Value = dwData["TZSUMMSTIME1"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK1", OracleType.NVarChar).Value = dwData["TZSUMMSOK1"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE1", OracleType.NVarChar).Value = dwData["TZSUMMEDATE1"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME1", OracleType.NVarChar).Value = dwData["TZSUMMETIME1"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK1", OracleType.NVarChar).Value = dwData["TZSUMMEOK1"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER1", OracleType.NVarChar).Value = dwData["TZSUMMFILLER1"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE2", OracleType.NVarChar).Value = dwData["TZSUMMSDATE2"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME2", OracleType.NVarChar).Value = dwData["TZSUMMSTIME2"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK2", OracleType.NVarChar).Value = dwData["TZSUMMSOK2"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE2", OracleType.NVarChar).Value = dwData["TZSUMMEDATE2"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME2", OracleType.NVarChar).Value = dwData["TZSUMMETIME2"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK2", OracleType.NVarChar).Value = dwData["TZSUMMEOK2"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER2", OracleType.NVarChar).Value = dwData["TZSUMMFILLER2"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE3", OracleType.NVarChar).Value = dwData["TZSUMMSDATE3"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME3", OracleType.NVarChar).Value = dwData["TZSUMMSTIME3"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK3", OracleType.NVarChar).Value = dwData["TZSUMMSOK3"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE3", OracleType.NVarChar).Value = dwData["TZSUMMEDATE3"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME3", OracleType.NVarChar).Value = dwData["TZSUMMETIME3"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK3", OracleType.NVarChar).Value = dwData["TZSUMMEOK3"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER3", OracleType.NVarChar).Value = dwData["TZSUMMFILLER3"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE4", OracleType.NVarChar).Value = dwData["TZSUMMSDATE4"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME4", OracleType.NVarChar).Value = dwData["TZSUMMSTIME4"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK4", OracleType.NVarChar).Value = dwData["TZSUMMSOK4"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE4", OracleType.NVarChar).Value = dwData["TZSUMMEDATE4"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME4", OracleType.NVarChar).Value = dwData["TZSUMMETIME4"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK4", OracleType.NVarChar).Value = dwData["TZSUMMEOK4"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER4", OracleType.NVarChar).Value = dwData["TZSUMMFILLER4"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE5", OracleType.NVarChar).Value = dwData["TZSUMMSDATE5"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME5", OracleType.NVarChar).Value = dwData["TZSUMMSTIME5"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK5", OracleType.NVarChar).Value = dwData["TZSUMMSOK5"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE5", OracleType.NVarChar).Value = dwData["TZSUMMEDATE5"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME5", OracleType.NVarChar).Value = dwData["TZSUMMETIME5"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK5", OracleType.NVarChar).Value = dwData["TZSUMMEOK5"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER5", OracleType.NVarChar).Value = dwData["TZSUMMFILLER5"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE6", OracleType.NVarChar).Value = dwData["TZSUMMSDATE6"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME6", OracleType.NVarChar).Value = dwData["TZSUMMSTIME6"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK6", OracleType.NVarChar).Value = dwData["TZSUMMSOK6"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE6", OracleType.NVarChar).Value = dwData["TZSUMMEDATE6"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME6", OracleType.NVarChar).Value = dwData["TZSUMMETIME6"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK6", OracleType.NVarChar).Value = dwData["TZSUMMEOK6"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER6", OracleType.NVarChar).Value = dwData["TZSUMMFILLER6"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE7", OracleType.NVarChar).Value = dwData["TZSUMMSDATE7"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME7", OracleType.NVarChar).Value = dwData["TZSUMMSTIME7"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK7", OracleType.NVarChar).Value = dwData["TZSUMMSOK7"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE7", OracleType.NVarChar).Value = dwData["TZSUMMEDATE7"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME7", OracleType.NVarChar).Value = dwData["TZSUMMETIME7"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK7", OracleType.NVarChar).Value = dwData["TZSUMMEOK7"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER7", OracleType.NVarChar).Value = dwData["TZSUMMFILLER7"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE8", OracleType.NVarChar).Value = dwData["TZSUMMSDATE8"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME8", OracleType.NVarChar).Value = dwData["TZSUMMSTIME8"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK8", OracleType.NVarChar).Value = dwData["TZSUMMSOK8"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE8", OracleType.NVarChar).Value = dwData["TZSUMMEDATE8"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME8", OracleType.NVarChar).Value = dwData["TZSUMMETIME8"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK8", OracleType.NVarChar).Value = dwData["TZSUMMEOK8"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER8", OracleType.NVarChar).Value = dwData["TZSUMMFILLER8"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE9", OracleType.NVarChar).Value = dwData["TZSUMMSDATE9"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME9", OracleType.NVarChar).Value = dwData["TZSUMMSTIME9"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK9", OracleType.NVarChar).Value = dwData["TZSUMMSOK9"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE9", OracleType.NVarChar).Value = dwData["TZSUMMEDATE9"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME9", OracleType.NVarChar).Value = dwData["TZSUMMETIME9"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK9", OracleType.NVarChar).Value = dwData["TZSUMMEOK9"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER9", OracleType.NVarChar).Value = dwData["TZSUMMFILLER9"].ToString(); 
          or1.Parameters.Add("TZSUMMSDATE10", OracleType.NVarChar).Value = dwData["TZSUMMSDATE10"].ToString(); 
          or1.Parameters.Add("TZSUMMSTIME10", OracleType.NVarChar).Value = dwData["TZSUMMSTIME10"].ToString(); 
          or1.Parameters.Add("TZSUMMSOK10", OracleType.NVarChar).Value = dwData["TZSUMMSOK10"].ToString(); 
          or1.Parameters.Add("TZSUMMEDATE10", OracleType.NVarChar).Value = dwData["TZSUMMEDATE10"].ToString(); 
          or1.Parameters.Add("TZSUMMETIME10", OracleType.NVarChar).Value = dwData["TZSUMMETIME10"].ToString(); 
          or1.Parameters.Add("TZSUMMEOK10", OracleType.NVarChar).Value = dwData["TZSUMMEOK10"].ToString(); 
          or1.Parameters.Add("TZSUMMFILLER10", OracleType.NVarChar).Value = dwData["TZSUMMFILLER10"].ToString(); 
          or1.Parameters.Add("TZFILLER", OracleType.NVarChar).Value = dwData["TZFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
